import pandas as pd					#导入pandas库
data = [[110, 120, 105], [95, 110, 108], [98, 80, 100], [112, 106, 97]]
index = ['王蒙', '李珊', '赵胜', '刘文']
columns = ['语文', '数学', '英语']
df = pd.DataFrame(data, index, columns)
print('保存的数据：\n', df)


df=pd.DataFrame(data,index,columns)
print('保存到‘score1’工作表中的数据:\n',df)
writer=pd.ExcelWriter('Score.xlsx')
df.to_excel(writer,sheet_name='score1')
df.iloc[0]=[105,118,100]
print('保存到‘score2’工作表中的数据:\n',df)
df.to_excel(writer,sheet_name='score2')
writer._save()
df1=pd.read_excel('Score.xlsx',sheet_name=['score1','score2'],index_col=0)
print('导入的数据:\n',df1)

